﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Jzy.Model.CRM
{
    public partial class CustomerContactInfo
    {
        public const string TABLE_NAME = "CustomerContact";
        public const string INSERT_SQL = "insert into CustomerContact ( [ID], [Name], [CustomerID], [IsDelete], [Duty], [Dept], [Gender], [OfficePhone], [HomePhone], [Mobile], [Email], [QQ], [MSN], [Address]) values ( @ID, @Name, @CustomerID, @IsDelete, @Duty, @Dept, @Gender, @OfficePhone, @HomePhone, @Mobile, @Email, @QQ, @MSN, @Address)";
        public const string UPDATE_SQL = "update CustomerContact set  [ID] = @ID, [Name] = @Name, [CustomerID] = @CustomerID, [IsDelete] = @IsDelete, [Duty] = @Duty, [Dept] = @Dept, [Gender] = @Gender, [OfficePhone] = @OfficePhone, [HomePhone] = @HomePhone, [Mobile] = @Mobile, [Email] = @Email, [QQ] = @QQ, [MSN] = @MSN, [Address] = @Address where ID = @ID";
        /// <summary>
        /// PK
        /// </summary>
        public Int32 ID
        {
            get;
            set;
        }
        /// <summary>
        /// 姓名
        /// </summary>
        public String Name
        {
            get;
            set;
        }
        /// <summary>
        /// 客户ID
        /// </summary>
        public Int32 CustomerID
        {
            get;
            set;
        }
        /// <summary>
        /// 是否逻辑删除
        /// </summary>
        public Boolean IsDelete
        {
            get;
            set;
        }
        /// <summary>
        /// 职务
        /// </summary>
        public String Duty
        {
            get;
            set;
        }
        /// <summary>
        /// 部门
        /// </summary>
        public String Dept
        {
            get;
            set;
        }
        /// <summary>
        /// 性别
        /// </summary>
        public int Gender
        {
            get;
            set;
        }
        /// <summary>
        /// 办公电话
        /// </summary>
        public String OfficePhone
        {
            get;
            set;
        }
        /// <summary>
        /// 家庭电话
        /// </summary>
        public String HomePhone
        {
            get;
            set;
        }
        /// <summary>
        /// 手机
        /// </summary>
        public String Mobile
        {
            get;
            set;
        }
        /// <summary>
        /// 电子邮件
        /// </summary>
        public String Email
        {
            get;
            set;
        }
        /// <summary>
        /// QQ
        /// </summary>
        public String QQ
        {
            get;
            set;
        }
        /// <summary>
        /// MSN
        /// </summary>
        public String MSN
        {
            get;
            set;
        }
        /// <summary>
        /// 家庭住址
        /// </summary>
        public String Address
        {
            get;
            set;
        }
    }

}
